How to insert values to identity column in SQL Server.

Question

Anonymous User · Answer

You can alllow insert to the identity field by setting IDENTITY_INSERT ON for a specific table.    Show below:SET IDENTITY_INSERT [Employee] ONand You can also disalllow insert to the identity field by setting IDENTITY_INSERT OFF for a specific  table. shown below:SET IDENTITY_INSERT [Employee] OFF and For Example:and CREATE TABLE [dbo].[Employee] (
    [EmpNo]       INT  IDENTITY (1, 1) NOT NULL,
    [EmpName]     VARCHAR (50) NOT NULL,
    [Salary]      DECIMAL (18) NOT NULL,
    [DeptName]    VARCHAR (50) NOT NULL,
    [Designation] VARCHAR (50) NOT NULL,
    PRIMARY KEY CLUSTERED ([EmpNo] ASC)and and and and );and SET IDENTITY_INSERT [Employee] ON
and and  
and INSERT INTO [Employee]([EmpNo],[EmpName],[Salary],[DeptName],[Designation]) VALUES(1,'Aditya',20000,'Development','Programmer')
INSERT INTO [Employee]([EmpNo],[EmpName],[Salary],[DeptName],[Designation]) VALUES(2,'Anupam',30000,'Development','Programmer')
and and  
and SET IDENTITY_INSERT [Employee] OFF 
INSERT INTO [Employee]([EmpName],[Salary],[DeptName],[Designation]) VALUES('Pawan',40000,'Development','Programmer')and select * from Employeeand

forum

How to insert values to identity column in SQL Server.

Anonymous User

Can you answer this question?

1 Answers

Liked By